﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="SmsServerDataSet" targetNamespace="http://tempuri.org/SmsServerDataSet.xsd" xmlns:mstns="http://tempuri.org/SmsServerDataSet.xsd" xmlns="http://tempuri.org/SmsServerDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="SmsServerConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="SmsServerConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.MSRI.DesktopAgent.Properties.Settings.GlobalReference.Default.SmsServerConnectionString" Provider="Microsoft.SqlServerCe.Client">
          </Connection>
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Sms_InboxTableAdapter" GeneratorDataComponentClassName="Sms_InboxTableAdapter" Name="Sms_Inbox" UserDataComponentName="Sms_InboxTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SmsServerConnectionString (Settings)" DbObjectName="Sms_Inbox" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [Sms_Inbox] WHERE (([ID] = @p1))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@p1" Precision="0" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [Sms_Inbox] ([From], [Time], [Body], [ID], [ToAddress]) VALUES (@p1, @p2, @p3, @p4, @p5)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" Scale="0" Size="0" SourceColumn="From" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@p2" Precision="0" Scale="0" Size="0" SourceColumn="Time" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" Scale="0" Size="0" SourceColumn="Body" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@p4" Precision="0" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p5" Precision="0" Scale="0" Size="0" SourceColumn="ToAddress" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     [From], [Time], Body, ID, ToAddress
FROM         Sms_Inbox</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [Sms_Inbox] SET [From] = @p1, [Time] = @p2, [Body] = @p3, [ID] = @p4, [ToAddress] = @p5 WHERE (([ID] = @p6))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" Scale="0" Size="0" SourceColumn="From" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@p2" Precision="0" Scale="0" Size="0" SourceColumn="Time" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" Scale="0" Size="0" SourceColumn="Body" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@p4" Precision="0" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p5" Precision="0" Scale="0" Size="0" SourceColumn="ToAddress" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@p6" Precision="0" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="From" DataSetColumn="From" />
              <Mapping SourceColumn="Time" DataSetColumn="Time" />
              <Mapping SourceColumn="Body" DataSetColumn="Body" />
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="ToAddress" DataSetColumn="ToAddress" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="SmsServerConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="DeleteInboxSms" Modifier="Public" Name="DeleteInboxSms" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy" UserSourceName="DeleteInboxSms">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>DELETE FROM [Sms_Inbox] WHERE (([ID] = @p1))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="p1" ColumnName="ID" DataSourceName="Sms_Inbox" DataTypeServer="DbType.Guid(16)" DbType="Guid" Direction="Input" ParameterName="@p1" Precision="0" Scale="0" Size="16" SourceColumn="ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="SmsServerConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="InboxInsertSms" Modifier="Public" Name="InboxInsertSms" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy1" UserSourceName="InboxInsertSms">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>INSERT INTO [Sms_Inbox] ([From], [Time], [Body], [ID]) VALUES (@p1, @p2, @p3, @p4)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="p1" ColumnName="From" DataSourceName="Sms_Inbox" DataTypeServer="DbType.String(15)" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" Scale="0" Size="50" SourceColumn="From" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="p2" ColumnName="Time" DataSourceName="Sms_Inbox" DataTypeServer="DbType.DateTime(8)" DbType="DateTime" Direction="Input" ParameterName="@p2" Precision="0" Scale="0" Size="8" SourceColumn="Time" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="p3" ColumnName="Body" DataSourceName="Sms_Inbox" DataTypeServer="DbType.String(2048)" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" Scale="0" Size="0" SourceColumn="Body" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="p4" ColumnName="ID" DataSourceName="Sms_Inbox" DataTypeServer="DbType.Guid(16)" DbType="Guid" Direction="Input" ParameterName="@p4" Precision="0" Scale="0" Size="16" SourceColumn="ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Sms_SentTableAdapter" GeneratorDataComponentClassName="Sms_SentTableAdapter" Name="Sms_Sent" UserDataComponentName="Sms_SentTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SmsServerConnectionString (Settings)" DbObjectName="Sms_Sent" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [Sms_Sent] WHERE (([ID] = @p1))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@p1" Precision="0" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [Sms_Sent] ([FromClient], [To], [Body], [Time], [Status], [ID]) VALUES (@p1, @p2, @p3, @p4, @p5, @p6)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" Scale="0" Size="0" SourceColumn="FromClient" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" Scale="0" Size="0" SourceColumn="To" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" Scale="0" Size="0" SourceColumn="Body" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@p4" Precision="0" Scale="0" Size="0" SourceColumn="Time" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@p5" Precision="0" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@p6" Precision="0" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     FromClient, [To], Body, [Time], Status, ID
FROM         Sms_Sent</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [Sms_Sent] SET [FromClient] = @p1, [To] = @p2, [Body] = @p3, [Time] = @p4, [Status] = @p5, [ID] = @p6 WHERE (([ID] = @p7))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" Scale="0" Size="0" SourceColumn="FromClient" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" Scale="0" Size="0" SourceColumn="To" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" Scale="0" Size="0" SourceColumn="Body" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@p4" Precision="0" Scale="0" Size="0" SourceColumn="Time" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@p5" Precision="0" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@p6" Precision="0" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@p7" Precision="0" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="FromClient" DataSetColumn="FromClient" />
              <Mapping SourceColumn="To" DataSetColumn="To" />
              <Mapping SourceColumn="Body" DataSetColumn="Body" />
              <Mapping SourceColumn="Time" DataSetColumn="Time" />
              <Mapping SourceColumn="Status" DataSetColumn="Status" />
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="SmsServerConnectionString (Settings)" DbObjectName="Sms_Sent" DbObjectType="Table" GenerateShortCommands="True" GeneratorSourceName="GetClientNamebyID" Modifier="Public" Name="GetClientNamebyID" QueryType="Scalar" ScalarCallRetval="System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy" UserSourceName="GetClientNamebyID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     FromClient
FROM         SMS_Sent
WHERE     (ID = @MessageID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="MessageID" ColumnName="ID" DataSourceName="SMS_Sent" DataTypeServer="DbType.Guid(16)" DbType="Guid" Direction="Input" ParameterName="@MessageID" Precision="0" Scale="0" Size="16" SourceColumn="ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="SmsServerConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="SentDeleteSms" Modifier="Public" Name="SentDeleteSms" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy1" UserSourceName="SentDeleteSms">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>DELETE FROM [Sms_Sent] WHERE (([ID] = @p1))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="p1" ColumnName="ID" DataSourceName="Sms_Sent" DataTypeServer="DbType.Guid(16)" DbType="Guid" Direction="Input" ParameterName="@p1" Precision="0" Scale="0" Size="16" SourceColumn="ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="SmsServerConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="SentInsertSms" Modifier="Public" Name="SentInsertSms" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy2" UserSourceName="SentInsertSms">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>INSERT INTO [Sms_Sent] ([FromClient], [To], [Body], [Time], [Status], [ID]) VALUES (@p1, @p2, @p3, @p4, @p5, @p6)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="p1" ColumnName="FromClient" DataSourceName="Sms_Sent" DataTypeServer="DbType.String(25)" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" Scale="0" Size="128" SourceColumn="FromClient" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="p2" ColumnName="To" DataSourceName="Sms_Sent" DataTypeServer="DbType.String(20)" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" Scale="0" Size="50" SourceColumn="To" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="p3" ColumnName="Body" DataSourceName="Sms_Sent" DataTypeServer="DbType.String(2048)" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" Scale="0" Size="0" SourceColumn="Body" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="p4" ColumnName="Time" DataSourceName="Sms_Sent" DataTypeServer="DbType.DateTime(8)" DbType="DateTime" Direction="Input" ParameterName="@p4" Precision="0" Scale="0" Size="8" SourceColumn="Time" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="p5" ColumnName="Status" DataSourceName="Sms_Sent" DataTypeServer="DbType.Byte(1)" DbType="Int16" Direction="Input" ParameterName="@p5" Precision="0" Scale="0" Size="1" SourceColumn="Status" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="p6" ColumnName="ID" DataSourceName="Sms_Sent" DataTypeServer="DbType.Guid(16)" DbType="Guid" Direction="Input" ParameterName="@p6" Precision="0" Scale="0" Size="16" SourceColumn="ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
              <DbSource ConnectionRef="SmsServerConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="SentStatusUpdateSms" Modifier="Public" Name="SentStatusUpdateSms" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy3" UserSourceName="SentStatusUpdateSms">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>UPDATE    Sms_Sent
SET              Status = @p5
WHERE     (ID = @p7)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="p5" ColumnName="Status" DataSourceName="Sms_Sent" DataTypeServer="DbType.Byte(1)" DbType="Int32" Direction="Input" ParameterName="@p5" Precision="0" Scale="0" Size="1" SourceColumn="Status" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="p7" ColumnName="ID" DataSourceName="Sms_Sent" DataTypeServer="DbType.Guid(16)" DbType="Guid" Direction="Input" ParameterName="@p7" Precision="0" Scale="0" Size="16" SourceColumn="ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Sms_BlockedListTableAdapter" GeneratorDataComponentClassName="Sms_BlockedListTableAdapter" Name="Sms_BlockedList" UserDataComponentName="Sms_BlockedListTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SmsServerConnectionString (Settings)" DbObjectName="Sms_BlockedList" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [Sms_BlockedList] WHERE (([BlockedNumber] = @p1))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" Scale="0" Size="0" SourceColumn="BlockedNumber" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [Sms_BlockedList] ([BlockedNumber], [Count]) VALUES (@p1, @p2)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" Scale="0" Size="0" SourceColumn="BlockedNumber" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" Scale="0" Size="0" SourceColumn="Count" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT [BlockedNumber], [Count] FROM [Sms_BlockedList]</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [Sms_BlockedList] SET [BlockedNumber] = @p1, [Count] = @p2 WHERE (([BlockedNumber] = @p3))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" Scale="0" Size="0" SourceColumn="BlockedNumber" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" Scale="0" Size="0" SourceColumn="Count" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" Scale="0" Size="0" SourceColumn="BlockedNumber" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="BlockedNumber" DataSetColumn="BlockedNumber" />
              <Mapping SourceColumn="Count" DataSetColumn="Count" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="SmsServerConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="IsBlocked" Modifier="Public" Name="IsBlocked" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy" UserSourceName="IsBlocked">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     COUNT(*) AS Counter
FROM         Sms_BlockedList
WHERE     (BlockedNumber = @number)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="number" ColumnName="BlockedNumber" DataSourceName="Sms_BlockedList" DataTypeServer="DbType.String(50)" DbType="String" Direction="Input" ParameterName="@number" Precision="0" Scale="0" Size="50" SourceColumn="BlockedNumber" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="SmsServerDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="SmsServerDataSet" msprop:Generator_DataSetName="SmsServerDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Sms_Inbox" msprop:Generator_UserTableName="Sms_Inbox" msprop:Generator_RowDeletedName="Sms_InboxRowDeleted" msprop:Generator_RowChangedName="Sms_InboxRowChanged" msprop:Generator_RowClassName="Sms_InboxRow" msprop:Generator_RowChangingName="Sms_InboxRowChanging" msprop:Generator_RowEvArgName="Sms_InboxRowChangeEvent" msprop:Generator_RowEvHandlerName="Sms_InboxRowChangeEventHandler" msprop:Generator_TableClassName="Sms_InboxDataTable" msprop:Generator_TableVarName="tableSms_Inbox" msprop:Generator_RowDeletingName="Sms_InboxRowDeleting" msprop:Generator_TablePropName="Sms_Inbox">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="From" msprop:Generator_UserColumnName="From" msprop:Generator_ColumnPropNameInRow="From" msprop:Generator_ColumnVarNameInTable="columnFrom" msprop:Generator_ColumnPropNameInTable="FromColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Time" msprop:Generator_UserColumnName="Time" msprop:Generator_ColumnPropNameInRow="Time" msprop:Generator_ColumnVarNameInTable="columnTime" msprop:Generator_ColumnPropNameInTable="TimeColumn" type="xs:dateTime" />
              <xs:element name="Body" msprop:Generator_UserColumnName="Body" msprop:Generator_ColumnPropNameInRow="Body" msprop:Generator_ColumnVarNameInTable="columnBody" msprop:Generator_ColumnPropNameInTable="BodyColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2048" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:string" />
              <xs:element name="ToAddress" msprop:Generator_UserColumnName="ToAddress" msprop:Generator_ColumnPropNameInRow="ToAddress" msprop:Generator_ColumnVarNameInTable="columnToAddress" msprop:Generator_ColumnPropNameInTable="ToAddressColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Sms_Sent" msprop:Generator_UserTableName="Sms_Sent" msprop:Generator_RowDeletedName="Sms_SentRowDeleted" msprop:Generator_RowChangedName="Sms_SentRowChanged" msprop:Generator_RowClassName="Sms_SentRow" msprop:Generator_RowChangingName="Sms_SentRowChanging" msprop:Generator_RowEvArgName="Sms_SentRowChangeEvent" msprop:Generator_RowEvHandlerName="Sms_SentRowChangeEventHandler" msprop:Generator_TableClassName="Sms_SentDataTable" msprop:Generator_TableVarName="tableSms_Sent" msprop:Generator_RowDeletingName="Sms_SentRowDeleting" msprop:Generator_TablePropName="Sms_Sent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="FromClient" msprop:Generator_UserColumnName="FromClient" msprop:Generator_ColumnPropNameInRow="FromClient" msprop:Generator_ColumnVarNameInTable="columnFromClient" msprop:Generator_ColumnPropNameInTable="FromClientColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="128" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="To" msprop:Generator_UserColumnName="To" msprop:Generator_ColumnPropNameInRow="To" msprop:Generator_ColumnVarNameInTable="columnTo" msprop:Generator_ColumnPropNameInTable="ToColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Body" msprop:Generator_UserColumnName="Body" msprop:Generator_ColumnPropNameInRow="Body" msprop:Generator_ColumnVarNameInTable="columnBody" msprop:Generator_ColumnPropNameInTable="BodyColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2048" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Time" msprop:Generator_UserColumnName="Time" msprop:Generator_ColumnPropNameInRow="Time" msprop:Generator_ColumnVarNameInTable="columnTime" msprop:Generator_ColumnPropNameInTable="TimeColumn" type="xs:dateTime" />
              <xs:element name="Status" msprop:Generator_UserColumnName="Status" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInTable="StatusColumn" type="xs:unsignedByte" default="0" />
              <xs:element name="ID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:string" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Sms_BlockedList" msprop:Generator_UserTableName="Sms_BlockedList" msprop:Generator_RowDeletedName="Sms_BlockedListRowDeleted" msprop:Generator_RowChangedName="Sms_BlockedListRowChanged" msprop:Generator_RowClassName="Sms_BlockedListRow" msprop:Generator_RowChangingName="Sms_BlockedListRowChanging" msprop:Generator_RowEvArgName="Sms_BlockedListRowChangeEvent" msprop:Generator_RowEvHandlerName="Sms_BlockedListRowChangeEventHandler" msprop:Generator_TableClassName="Sms_BlockedListDataTable" msprop:Generator_TableVarName="tableSms_BlockedList" msprop:Generator_RowDeletingName="Sms_BlockedListRowDeleting" msprop:Generator_TablePropName="Sms_BlockedList">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="BlockedNumber" msprop:Generator_UserColumnName="BlockedNumber" msprop:Generator_ColumnVarNameInTable="columnBlockedNumber" msprop:Generator_ColumnPropNameInRow="BlockedNumber" msprop:Generator_ColumnPropNameInTable="BlockedNumberColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Count" msprop:Generator_UserColumnName="Count" msprop:Generator_ColumnVarNameInTable="columnCount" msprop:Generator_ColumnPropNameInRow="Count" msprop:Generator_ColumnPropNameInTable="CountColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Sms_Inbox" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Sms_Sent_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Sms_Sent" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Sms_BlockedList_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Sms_BlockedList" />
      <xs:field xpath="mstns:BlockedNumber" />
    </xs:unique>
  </xs:element>
</xs:schema>